Select a Ledger, typically TRADING. Select a Period. Then click the 'Populate' button which will fill the left Main column with the corresponding account names from the General Ledger Chart of Accounts. Tick 'Sub Accounts' to diplay Sub Accounts if necessary.
Create and view budgets over a range of financial years.
Use this button to fill the left edge Main & Sub columns with account names from the General Ledger Chart of Accounts.
Copy budget details from a another budget.
Clear all entries in the Yellow Fields
Lennox Computer - LILAC Document Context Help
General Ledger Budget Entry
Use this Document to plan intended expenditure and revenue. Once a budget has been established, it can be updated, and compared against actual figures by running the General Ledger - Profit or Loss - Budget Compare report.
Replace figures with the outcomes/actual figures from last year.
Enter a total here and press 'Tab' to to evenly distribute the amount over July to June. Or, enter figures manually.
General Ledger Budget Entry
Purpose: This document allows the user to establish a budget for accounts and sub accounts.
Prerequisites: The Chart of Accounts must have already been created via the General Ledger - Chart of Accounts document, and the Chart of Sub Accounts must have already been created via the General Ledger - Chart of Sub Accounts document.
Context: This document provides the facility for the user to enter in monthly, and yearly budgets for main accounts and sub accounts that have been created via the General Ledger - Chart of Accounts and the General Ledger - Chart of Sub Accounts documents. The accounts are presented in this document in a similar order to the presentation on the Profit and Loss - By Month report. However, because LILAC has a very dynamic approach to "General Ledger Accounts", not all accounts shown on that report will be visible on this document.
From Ledger: When entering a budget you should select the TRADING ledger. Period: Select a finacial year. A template can be created with a blank period Field (Strike Space-bar in the Period Field).
Main: Displays the main account. Sub: Displays the sub account. Total: Type in the budget for 12 months. Striking 'Tab' or 'Enter' will automatically divide the total value evenly over the each month. Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr, May, Jun
Total / 12. Be aware that it is possible for the sum of each month to be not equal to the Total column. This is caused by rounding. To correct this problem, you can enter the remainder into the month of Jun. If 10,000 is entered into the Total field, each month will be set to 833. If the Calculate is clicked, the Total field would then be set to 9996. Set the Jun field to 837 to correct this. Percent: Displays the percentage the total of this item makes up of the section total. Running Total: Displays the running total for the section.
Transaction Processing Button Description: Populate: Clicking the Populate button will create the budget document from the Chart of Accounts and Chart of Sub Accounts Calculate: Clicking the Calculate button will recalculate the Total, Percent and Running Total fields. Clear!: Clicking the Clear! button will clear all budget records. Delete!: Clicking the Delete! button will erase all budget records.
From Here: Once a budget has been established, it can be updated, and compared against actual figures by running the General Ledger - Profit or Loss - Budget Compare report.
